﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Jzy.Workflow.Form
{
    public partial class FlowFormInfo
    {
        public const string TABLE_NAME = "FlowForm";
        public const string INSERT_SQL = "insert into FlowForm ( [ID], [Name], [Code], [FlowID], [FormData], [InputTime], [CreatorID], [CreatorName], [State]) values ( @ID, @Name, @Code, @FlowID, @FormData, @InputTime, @CreatorID, @CreatorName, @State)";
        public const string UPDATE_SQL = "update FlowForm set  [ID] = @ID, [Name] = @Name, [Code] = @Code, [FlowID] = @FlowID, [FormData] = @FormData, [InputTime] = @InputTime, [CreatorID] = @CreatorID, [CreatorName] = @CreatorName, [State] = @State where ID = @ID";
        /// <summary>
        /// PK
        /// </summary>
        public Int32 ID
        {
            get;
            set;
        }
        /// <summary>
        /// 表单标题，默认为工作流的名称
        /// </summary>
        public String Name
        {
            get;
            set;
        }
        /// <summary>
        /// 发文编号
        /// </summary>
        public String Code
        {
            get;
            set;
        }
        /// <summary>
        /// 流程ID
        /// </summary>
        public Int32 FlowID
        {
            get;
            set;
        }
        /// <summary>
        /// 表单数据
        /// </summary>
        public String FormData
        {
            get;
            set;
        }
        /// <summary>
        /// 拟稿时间
        /// </summary>
        public DateTime InputTime
        {
            get;
            set;
        }
        /// <summary>
        /// 拟稿人ID
        /// </summary>
        public Int32 CreatorID
        {
            get;
            set;
        }
        /// <summary>
        /// 拟稿人姓名
        /// </summary>
        public String CreatorName
        {
            get;
            set;
        }
        /// <summary>
        /// 流转中、暂停、已结束、已归档
        /// </summary>
        public Int32 State
        {
            get;
            set;
        }
    }


}
